Installing PostgreSQL 7.3.2 on FreeSD 4.7, I found these discrepancies
between the "Short Version" instructions in the INSTALL file and "reality".
Short Version
./configure
gmake
1) The "Longer Version" makes note of a "gmake check" option for testing.
This SHOULD be mentioned in the short version as well!
su
gmake install
adduser postgres
2) It should be noted here to set the shell as /bin/sh or something similar
(e.g. bash) or else the postmaster command below will fail. Specifically, do
not use a Csh equivalent or /sbin/nologin.
mkdir /usr/local/pgsql/data
chown postgres /usr/local/pgsql/data
3) It should be noted here that the directory /usr/local/pgsql should also be
chown'd to postgresql, or the logfile created below with the postmaster
command will not be able to be written.
4) I can't help but wonder why the
make install
didn't do the adduser, create the data directory, and set ownership
correctly. The (FreeBSD ports collection version of) PostgreSQL 7.2.2 did the
adduser for me...
5) Subdirs of my /usr/local/bin/pgsql directory have ownership root:wheel
(due to having been created before the postgres user existed).
drwxr-xr-x 2 root wheel 512 Feb 11 19:30 bin
drwxr-xr-x 3 root wheel 512 Feb 11 19:30 doc
drwxr-xr-x 4 root wheel 512 Feb 11 19:30 include
drwxr-xr-x 2 root wheel 1024 Feb 11 19:30 lib
drwxr-xr-x 4 root wheel 512 Feb 11 19:30 man
drwxr-xr-x 2 root wheel 512 Feb 11 19:30 share
I see nothing in the INSTALL doc to cover these permissions and do not know,
therefore, if they are "correct", if it is "OK" to change the ownership to
postgres, or... what? I find this disturbing. Please update the docs (and
the install process) to handle the ownership of this directory.
--
- Vicki
Vicki Brown ZZZ Journeyman Sourceror:
P.O. Box 1269 zz |\ _,,,---,,_ Scripts & Philtres
San Bruno, CA zz /,`.-'`' -. ;-;;,_ Perl, Unix, MacOS
94066 USA |,4- ) )-,_. ,\ ( `'-'
mailto:vlb@cfcl.com '---''(_/--' `-'\_) http://www.cfcl.com/~vlb